library(readr)
## Warning: package 'readr' was built under R version 3.6.2
X<-read_table("https://www.fhwa.dot.gov/bridge/nbi/2020/AL20.txt",col_names = FALSE)
## 
## ── Column specification ───────────────────────────────────────────────────
## cols(
##   .default = col_character()
## )
## ℹ Use `spec()` for the full column specifications.
## Warning: 12806 parsing failures.
## row col   expected     actual                                                file
##   2  -- 21 columns 20 columns 'https://www.fhwa.dot.gov/bridge/nbi/2020/AL20.txt'
##   4  -- 21 columns 22 columns 'https://www.fhwa.dot.gov/bridge/nbi/2020/AL20.txt'
##   5  -- 21 columns 16 columns 'https://www.fhwa.dot.gov/bridge/nbi/2020/AL20.txt'
##   6  -- 21 columns 16 columns 'https://www.fhwa.dot.gov/bridge/nbi/2020/AL20.txt'
##   7  -- 21 columns 20 columns 'https://www.fhwa.dot.gov/bridge/nbi/2020/AL20.txt'
## ... ... .......... .......... ...................................................
## See problems(...) for more details.
X
str(X)
## Classes 'spec_tbl_df', 'tbl_df', 'tbl' and 'data.frame': 16155 obs. of  21 variables:
##  $ X1 : chr  "01400000000000S7021610400700905300000PERDIDO" "01400000000000S7031610400300905303004PERDIDO" "0140000000000M00221810000000011319000UCHEE" "0140000008830399001410008800205900000LITTLE" ...
##  $ X2 : chr  "CREEK" "CREEK" "CREEK" "BEAR" ...
##  $ X3 : chr  "IRR" "IRR" "101ST" "CR." ...
##  $ X4 : chr  "BIA" "BIA" "AIRBORNE" "DAM" ...
##  $ X5 : chr  "RTE" "RTE" "RD" "SPW" ...
##  $ X6 : chr  "4007" "4003" "3.4" "CO." ...
##  $ X7 : chr  "11.4KM" "ON" "KM" "RD" ...
##  $ X8 : chr  "NW" "LYNN" "S" "88" ...
##  $ X9 : chr  "OF" "MCGEE" "OF" "LITTLE" ...
##  $ X10: chr  "ATMORE," "ROAD" "SUNSHINE" "BEAR" ...
##  $ X11: chr  "AL" "999900011000000000000000310620200873408900033626209200202000001592019500650000111150000000000A15501000001000009"| __truncated__ "RD" "CR" ...
##  $ X12: chr  "999900015000000000000000310610940873413480033626209199902000000502019500970300111150000000000A15505000001000009"| __truncated__ "000000021924N" "999900000000" "DAM" ...
##  $ X13: chr  "000000021924N" "N" "0032174330-0845837.0183747409194202000003752017401040000001150000000000A151040000030000073001830004300060060073"| __truncated__ "999900000000" ...
##  $ X14: chr  "N" "N" "Y60N" "0034270600087581200016367670819740200000430201750116099011115N000000000A195050000050000086001400006550000000087"| __truncated__ ...
##  $ X15: chr  "N" "0000000000000000002019" "1017" "061824N" ...
##  $ X16: chr  "0000000000000000002019" "0" "0000010000010000022019" "N" ...
##  $ X17: chr  "0" "0N2" "0N2" "N" ...
##  $ X18: chr  "0N2" "0100002608010" "0000001100350" "0N2" ...
##  $ X19: chr  "0100002601010" "Y800020020390000Y62" "Y50004002039" "0000001000050" ...
##  $ X20: chr  "Y800005920390000Y62" "G70000013328" "Y74" "Y50006002037" ...
##  $ X21: chr  "G70000014550" NA "F50000038700" "Y67" ...
##  - attr(*, "problems")=Classes 'tbl_df', 'tbl' and 'data.frame': 12806 obs. of  5 variables:
##   ..$ row     : int  2 4 5 6 7 8 9 10 12 13 ...
##   ..$ col     : chr  NA NA NA NA ...
##   ..$ expected: chr  "21 columns" "21 columns" "21 columns" "21 columns" ...
##   ..$ actual  : chr  "20 columns" "22 columns" "16 columns" "16 columns" ...
##   ..$ file    : chr  "'https://www.fhwa.dot.gov/bridge/nbi/2020/AL20.txt'" "'https://www.fhwa.dot.gov/bridge/nbi/2020/AL20.txt'" "'https://www.fhwa.dot.gov/bridge/nbi/2020/AL20.txt'" "'https://www.fhwa.dot.gov/bridge/nbi/2020/AL20.txt'" ...
##  - attr(*, "spec")=
##   .. cols(
##   ..   X1 = col_character(),
##   ..   X2 = col_character(),
##   ..   X3 = col_character(),
##   ..   X4 = col_character(),
##   ..   X5 = col_character(),
##   ..   X6 = col_character(),
##   ..   X7 = col_character(),
##   ..   X8 = col_character(),
##   ..   X9 = col_character(),
##   ..   X10 = col_character(),
##   ..   X11 = col_character(),
##   ..   X12 = col_character(),
##   ..   X13 = col_character(),
##   ..   X14 = col_character(),
##   ..   X15 = col_character(),
##   ..   X16 = col_character(),
##   ..   X17 = col_character(),
##   ..   X18 = col_character(),
##   ..   X19 = col_character(),
##   ..   X20 = col_character(),
##   ..   X21 = col_character()
##   .. )